<?php 
/*
require_once('db/dba.php');
db_connect();

include "db/db_con.php";

*/
$host="localhost";
$dbusername="travelwebsite";
$password="Travel@123";
$db_name="travelwebsite";


mysql_connect("$host","$dbusername","$password")or die("unable to connect");
mysql_select_db("$db_name")or die("can not select db");



echo "select count(*) as cnt from tblpayments where  status=0 ";
	$qchk=mysql_fetch_array(mysql_query("select count(*) as cnt from tblpayments where  status=0 "));
	if($qchk['cnt']==0)
	{
	
	$qin=mysql_query(" insert into tblpayments 
(
select null,'','',0
)
 ");
echo  $qchk['cnt'];
	}
	
 $q_1=mysql_fetch_array(mysql_query("select *  from tblpayments where  status=0"));
 $merchantTxnIdNo=$q_1['merchantTxnId'];
	echo "dff = $merchantTxnIdNo";
	
	?>
	